CREATE TABLE [dbo].[OrganizationMain]
(
[OrganizationKey] [uniqueidentifier] NOT NULL CONSTRAINT [DF_OrganizationMain_OrganizationKey] DEFAULT (newid()),
[Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_OrganizationMain_Name] DEFAULT (''),
[Description] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_OrganizationMain_Description] DEFAULT (''),
[CreatedByUserKey] [uniqueidentifier] NOT NULL,
[CreatedOn] [datetime] NOT NULL CONSTRAINT [DF_OrganizationMain_CreatedOn] DEFAULT (getdate()),
[UpdatedByUserKey] [uniqueidentifier] NOT NULL,
[UpdatedOn] [datetime] NOT NULL CONSTRAINT [DF_OrganizationMain_UpdatedOn] DEFAULT (getdate()),
[MarkedForDeleteOn] [datetime] NULL,
[DefaultDepartmentGroupKey] [uniqueidentifier] NOT NULL,
[IsDefault] [bit] NOT NULL CONSTRAINT [DF_OrganizationMain_IsDefault] DEFAULT ((0))
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[OrganizationMain] ADD CONSTRAINT [PK_OrganizationMain] PRIMARY KEY CLUSTERED ([OrganizationKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[OrganizationMain] ADD CONSTRAINT [AK_OrganizationMain_Name] UNIQUE NONCLUSTERED ([Name]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_OrganizationMain_CreatedByUserKey] ON [dbo].[OrganizationMain] ([CreatedByUserKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_OrganizationMain_DefaultDepartmentGroupKey] ON [dbo].[OrganizationMain] ([DefaultDepartmentGroupKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_OrganizationMain_UpdatedByUserKey] ON [dbo].[OrganizationMain] ([UpdatedByUserKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[OrganizationMain] ADD CONSTRAINT [FK_OrganizationMain_GroupMain] FOREIGN KEY ([DefaultDepartmentGroupKey]) REFERENCES [dbo].[GroupMain] ([GroupKey])
GO
ALTER TABLE [dbo].[OrganizationMain] ADD CONSTRAINT [FK_OrganizationMain_UniformRegistry] FOREIGN KEY ([OrganizationKey]) REFERENCES [dbo].[UniformRegistry] ([UniformKey])
GO
ALTER TABLE [dbo].[OrganizationMain] ADD CONSTRAINT [FK_OrganizationMain_UserMain_CreatedBy] FOREIGN KEY ([CreatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO
ALTER TABLE [dbo].[OrganizationMain] ADD CONSTRAINT [FK_OrganizationMain_UserMain_UpdatedBy] FOREIGN KEY ([UpdatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO